package com.huabo.monitor.mapper;

import com.huabo.monitor.entity.TblTestelement;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author yhr
 * @since 2022-09-08
 */
public interface TblTestelementMapper extends BaseMapper<TblTestelement> {


    @Select("${sql}")
    List<TblTestelement> querySql(@Param("sql") String sql);
    @Select("SELECT DISTINCT ment.* from TBL_TESTELEMENT ment left join TBL_TESTPLAN pa on ment.templId=pa.TESTTEMID WHERE pa.testplanid=#{panid}")

    List<TblTestelement> queryByPanId(BigDecimal panid);
}
